代码见下
初学java
不知道我这样写有什么地方错啦··
编译器总是报错········import java.sql.*;
public class Add_stu {
public static void main(String[] args)
{
String sql;
Connection conn;
Statement stmt;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:Mydata";
String user = "";
String password = "";
conn = DriverManager.getConnection(url,user,password);
sql = "insert into info" + "(name,id,sex,major)" +
"values('寒',60,'男','软件')";
stmt = conn.createStatement();
rs = stmt.executeUpdate(sql);
rs.close ();
stmt.close ();
conn.close ();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
初学java
不知道我这样写有什么地方错啦··
编译器总是报错········import java.sql.*;
public class Add_stu {
public static void main(String[] args)
{
String sql;
Connection conn;
Statement stmt;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:Mydata";
String user = "";
String password = "";
conn = DriverManager.getConnection(url,user,password);
sql = "insert into info" + "(name,id,sex,major)" +
"values('寒',60,'男','软件')";
stmt = conn.createStatement();
rs = stmt.executeUpdate(sql);
rs.close ();
stmt.close ();
conn.close ();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
我是真的不会··········
jbuilder2006报错如下·
"Add_stu.java": incompatible types; found : int, required: java.sql.ResultSet at line 34, column 25
改成 stmt.executeUpdate(sql);
import java.sql.SQLException;
import javax.sql.DataSource;import org.apache.commons.dbcp.BasicDataSource;public class test{
private static String strDriver = "com.mysql.jdbc.Driver";
private static String strURL = "jdbc:mysql://localhost/test";
private static String insertSql = "insert into info" + "(name,id,sex,major)" +
"values('寒',60,'男','软件')";
private Connection conn;
private PreparedStatement pst;
public static DataSource getDataSource() {
// 初始化数据源
BasicDataSource ds = new BasicDataSource();
ds.setDriverClassName(strDriver);
ds.setUsername("");
ds.setPassword("");
ds.setUrl(strURL);
return ds;
}
public void insertSql(){
try {
conn = getDataSource().getConnection();
pst = conn.prepareStatement(insertSql);
int rows = pst.executeUpdate();
if (rows != 1) {
System.out.println("insert fail...");
} else {
System.out.println("insert success...");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally{
try {
ps.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
拿以前的代码给你,比较不规范,凑和的看吧
int num = stmt.executeUpdate(sql);
if(num>0){
// 成功
}
// rs.close() 这个也去掉吧!
理由:"Add_stu.java": incompatible types; found : int, required: java.sql.ResultSet at line 34, column 25
只用stmt.executeUpdate(sql)的话
就提示下面那两段话啦···········application main class is not configuredunable to start runtime due to incomplete configuration
改用javac编译的话就成功啦···········