/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package anketsitesi;
import com.mysql.jdbc.Driver;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
 *
 * @author mem
 */
public class db {
String url = "jdbc:mysql://localhost:3306/anket?useUnicode=true&characterEncoding=UTF-8";
    String kullaniciadi = "root";
    String sifre = "";

    public Statement Baglan() throws SQLException {
        DriverManager.registerDriver(new Driver());
     Connection con=DriverManager.getConnection(url, kullaniciadi, sifre);
     Statement st=con.createStatement();
     return st;

    }

    public ResultSet sorgula(String query) throws SQLException {
        Statement st = this.Baglan();

        ResultSet rs = st.executeQuery(query);
        return rs;
    }
    public void Kaydet(String query) throws SQLException{
    Statement s=this.Baglan();
    s.execute(query);
    }
}