登录mysql并添加信息

来源:互联网 发布:华南师范大学网络平台 编辑:程序博客网 时间:2024/06/08 02:55
package sql;








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


import org.junit.Test;






public class test {
@Test
public void fun1() throws SQLException, ClassNotFoundException {
String driverClassName = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/number";
String username = "root";
String password = "123";
Class.forName(driverClassName);
Connection con=DriverManager.getConnection(url,username,password);
Statement stmt=con.createStatement(); 
String sql="insert into first values('lisi',20,'man',67,'1997-06-24','game','jlju',null)";
int x=stmt.executeUpdate(sql);
System.out.println(x);
}
}
原创粉丝点击