这是程序packagefirst;importjava.sql.Statement;importjava.io.IOException;importjava.sql.Connection;importjava.sql.DriverManager;importjava.util.Properties;importcom.mysql....
这是程序
package first;
import java.sql.Statement;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;
import com.mysql.jdbc.Driver;
public class JDBCTest3
{
public static void main(String[] args)
{
Properties prop=null;
try
{
prop=new Properties();
prop.load(JDBCTest3.class.getResourceAsStream("/first/database.properties"));
}
catch(IOException e2)
{
System.out.println("读取映射文件发生异常");
}
try
{
Class.forName("com.mysql.jdbc.Driver");
}
catch(ClassNotFoundException e1)
{
System.out.println("加载驱动失败");
}
try
{
Connection conn=
DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc",prop);
Statement stmt=conn.createStatement();
String sql="insert into student values(3,'Lee',22)";
int row=stmt.executeUpdate(sql);
System.out.println("数据库中更新了"+row+"条数据");
stmt.close();
conn.close();
}catch(Exception e)
{
System.out.println("数据库操作过程发生异常");
}
}
}
展开