String driver = "com.mysql.jdbc.Driver" ;//服务器路径与数据库名String url = "jdbc:mysql://127.0.0.1:3306/classs" ;//操作数据库的用户String user = "root" ;//数据库密码String password = " " ;//加载驱动try {Class . forName ( driver );} catch ( ClassNotFoundException e1 ) {e1 . printStackTrace ();}//获取链接Connection conn = null ;try {conn = ( Connection ) DriverManager . getConnection ( url , user , password );} catch ( SQLException e ) {e . printStackTrace ();}//创建处理对象Statement statement = null ;try {statement = ( Statement ) conn . createStatement ();} catch ( SQLException e ) {e . printStackTrace ();}//编写sql语句String sql = "select * from user where person_number='830682000102238';" ;//执行sql语句ResultSet res = null ;try {res = statement . executeQuery ( sql );while ( res . next ()){//输出数据表里字段为id的字段名System . out . print ( res . getString ( "id" ));}} catch ( SQLException e ) {e . printStackTrace ();}try {res . close ();//关闭操作statement . close ();conn . close ();} catch ( SQLException e ) {// TODO 自动生成的 catch 块e . printStackTrace ();}
实现数据库与项目的链接
最新推荐文章于 2024-01-31 22:14:35 发布