Travel Web Design
no vote
<% Connection conn=null; try { String strUser1=request.getParameter("user"); byte[] strname=strUser1.getBytes("ISO8859-1"); strUser1=new String(strname); Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); String strConn="jdbc:microsoft:sqlserver://10.200.28.124:1433;DatabaseName=travel"; String strUser="sa"; String strPassword="123"; conn=DriverManager.getConnection(strConn,strUser,strPassword); Statement stmt=conn.createStatement(); String strSql="select * from yonghu where name='"+strUser1; ResultSet rs=stmt.executeQuery(strSql); %>