useraction.java

来自「java编写聊天室」· Java 代码 · 共 52 行

/**
 * 
 */
package user.action;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import user.entity.*;

/**
 * @author Administrator
 *
 */
public class UserAction {
	public static boolean insert(User user)
	{
		 try{      
			    String RL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
		        String name ="sa";
		        String password = "sa";
		        String sqlStr2="insert into yonghu values('"+user.getUserName()+"','"+user.getUserPassword()+"','"+
		        user.getUserSex()+"')";
	            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
	           
	            Connection con = DriverManager.getConnection(RL,name,password);
	          
	            Statement st = con.createStatement();          
	            System.out.println( "创建Statement成功!" );
	            st.executeUpdate(sqlStr2);    
	            System.out.println( "插入数据库成功!" );
	            System.out.println( "----------------!" );
	            
	           
	          
	        
	            return true;

	           
	            
	        }
	        catch(Exception err){
	            
	            return false;
	        }
	         
	    
	}

}