实现数据库与项目的链接

最新推荐文章于 2024-01-31 22:14:35 发布

醉梦无生

最新推荐文章于 2024-01-31 22:14:35 发布

阅读量938

点赞数 2

文章标签：数据库 string

本文链接：https://blog.csdn.net/qq_38395397/article/details/70289403

版权

 
             
  
  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
  
  ();
 
 
 
 			
  
  }