Question

怎样用myeclipse实现一个对数据库中的数据添加的操作

Answer 1

package com.ytj.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Create {
private Connection conn;
private Statement stmt;
private ResultSet rs;

String sql="insert into register(name,password)values('z','123')";
public void SqlConnection(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ex){
ex.printStackTrace();
}
String url="jdbc:odbc:fred";
try{
conn=DriverManager.getConnection(url);
stmt=conn.createStatement();
}
catch(SQLException ex){
ex.printStackTrace();
}

}
public void Register(){
rs=stmt.executeQuery("insert into register(name,password)values('"+name+"','"+password+"')");
}public void Close()throws Exception{
rs.close();
stmt.close();
conn.close();
}
public void main() throws Exception{
Create create=new Create();
create.SqlConnection();
create.Register();
create.Close();
}
}