--Thod 1 Gunakan Java Web untuk terhubung ke driver MySQL di file JSP
<%@page language = "java" import = "java.util.*" pageEncoding = "UTF-8"%> <%@page impor = "java.sql.connection"%> <%@page impor = "java.sql.driverManager"%> <%@page impor = "com.mysql.jd.jd.jd.jd.driver"%> <%@page Import = "com.mysql.jd.jd.jd.driver"%@%@page@page@page@@@page@@@page "page. Impor = "java.sql.sqlexception"%> <%@page impor = "java.sql.driver.*"%> <%@page impor = "java.util.*"%> <!-impor semua paket sumber daya Java-> <%@halaman impor = "java.sql.*"%> <! request.getContextPath (); String basePath = request.getScheme ()+": //"+request.getServerName ()+":"+request.getServerport ()+path+"/"; %> <! Doctype html public "-// w3c // dtd html 4.01 transisi // en"> <html> <head> <base href = "<%= Basepath%>"> <title> methpa letning = "no-conte =" no-cande = "no-conte =" no-conte = "no-conte =" no-cande = http-equiv = "cache-control" content = "no-cache"> <meta http-equiv = "kedaluwarsa" konten = "0"> <meta http-equiv = "kata kunci" konten = "kata kunci1, kata kunci2, koki"> <meta http http-equiv = "koki" ini = "ini" type="text/css" href="styles.css"> --> </head> <body> <% try{ Class.forName("com.mysql.jdbc.Driver");//Load the database driver and register it with the driver manager String URL="jdbc:mysql://localhost:3306/test";//Database connection string localhost means that the machine can Juga gunakan alamat IP atau nama komputer 3306 untuk mewakili tes port layanan untuk mewakili nama basis data string username = "xiyi yindie"; // database nama pengguna string kata sandi = "123"; // kata sandi basis data 123 // koneksi cn = driverManager.getConnection ("jdbc: mysql: // localhost: 3306/test", "xiyi i Memories hidden kupu -kupu", "123"); // Metode 1 koneksi cn = driverManager.getConnection (url, username, kata sandi); apakah koneksi database berhasil keluar.println ("Koneksi database berhasil!"); // informasi koneksi output cn.close (); // tutup koneksi database} else {out.println ("Koneksi database gagal!"); // informasi koneksi output cn.close (); // tutup koneksi basis data}} catch (classnotfoundException e) {e.printstacktrace (); out.println (e.tostring ()+"<br> Kelas driver tidak dapat dimuat!"); } catch (sqlexception e) {e.printstacktrace (); out.println (e.tostring ()+"<br> Koneksi database tidak dapat dimuat!"); } %> <br> <br> <br> <br> <bentuk id = "form1" name = "form1" method = "post" style = "text-align: center" action = "index1.jsp"> <input type = "kirim" name = "kirim" value = "Connect SQL Server"/</form> </body> </htm--- Metode 1 Gunakan Java Web untuk terhubung ke driver SQLSever di file JSP
<%@page language = "java" import = "java.util.*" pageEncoding = "UTF-8"%> <%@page impor = "java.sql.connection"%> <%@page impor = "java.sql.driverManager"%> <%@page impor = "com.mysql.jd.jd.jd.jd.driver"%> <%@page Import = "com.mysql.jd.jd.jd.driver"%@%@page@page@page@@@page@@@page "page. Impor = "java.sql.sqlexception"%> <%@page impor = "java.sql.driver.*"%> <%@page impor = "java.util.*"%> <!-impor semua paket sumber daya Java-> <%@halaman impor = "java.sql.*"%> <! request.getContextPath (); String basePath = request.getScheme ()+": //"+request.getServerName ()+":"+request.getServerport ()+path+"/"; %> <! Doctype html public "-// w3c // dtd html 4.01 transisi // en"> <html> <head> <base href = "<%= basepath%>"> <title> <"metmace =" no-conte> </title> </title> <MetA http-equiv = "MetA =" no-conte = "no-conte =" no-conte = "no-conte =" no-contpa = "no-conte =" no-conte- " http-equiv = "cache-control" content = "no-cache"> <meta http-equiv = "kedaluwarsa" konten = "0"> <meta http-equiv = "kata kunci" konten = "kata kunci1, kata kunci2, koki"> <meta http http-equiv = "koki" ini = "ini" type = "text/css" href = "styles.css"> -> </head> <body> <% coba {koneksi conn = null; Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");//Load the database driver and register it with the driver manager String URL="jdbc:sqlserver://localhost:1433;DataBaseName=msdb";//Database connection string localhost means that the machine can also use the IP address or the name of the computer 1433 Untuk mewakili port layanan DatabaseName = ConstructionDB atau DatabaseName = MSDB mewakili nama string basis data username = "SA"; // database nama pengguna string kata sandi = "123"; // kata sandi basis data 123 // conn = driverManager.getConnection ("jdbc: sqlserver: // localhost: 1433; databaseName = msdb", "SA", "123"); // Metode 1 Koneksi CN = driverManager.getConnection (url, username, kata sandi); // apakah itu cn = driverManager. Koneksi database berhasil out.println ("Koneksi database berhasil!"); // informasi koneksi output cn.close (); // tutup koneksi database} else {out.println ("Koneksi database gagal!"); // informasi koneksi output cn.close (); // tutup koneksi basis data}} catch (classnotfoundException e) {e.printstacktrace (); out.println (e.tostring ()+"<br> Kelas driver tidak dapat dimuat!"); } catch (sqlexception e) {e.printstacktrace (); out.println (e.tostring ()+"<br> Koneksi database tidak dapat dimuat!"); } %> <br> <br> <br> <br> <bentuk id = "form1" name = "form1" method = "post" style = "text-align: center" action = "index.jsp"> <input type = "kirim" name = "kirim" value = "Connect sql saya"/> </form> </body> </htm> htm saya sql "saya/form--- Metode 2 Gunakan Java Web untuk menghubungkan driver yang menghubungkan SQLSever dan MySQL di file kelas
kelas publik Conndao {OpenConn koneksi publik () {Connection conn = null; Coba {// Ini adalah objek parameter koneksi database yang terhubung ke [mysql] class.forname ("com.mysql.jdbc.driver"); // 【SQL Server Link】 class.forname ("com.microsoft.sqlserver.jdbc.sqlServerDriver"); // Muat driver database dan daftarkan dengan manajer driver // Ini adalah objek parameter koneksi database yang terhubung ke [mysql] [metode 1]/* class.forname ("com.mysql.jdbc.driver"); // Muat driver MySQL. String url = "jdbc: mysql: // localhost: 3306/db_database10"; String username="小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小小conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/db_database10","Xiyiyindie","123");//Implement connection parameter library name username and password} catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); }/ * String url = "jdbc: mysql: // localhost: 3306/db_database10" // 【SQL Server Link】 Conn = DriverManager.getConnection ("JDBC: SQLServer: // LocalHost: 1433; DataBaseName = db_database10", "kupu-kupu hidden {qwe199509060"); e.printstacktrace ();} return conn;Catatan: Di sini Anda perlu mengunduh paket driver. Sumber daya saya termasuk paket driver MySQL dan SQL Server. Unduhnya sendiri!
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Kode ini adalah sebagai berikut, dan tidak ada analisis:
impor java.sql.*; Kelas Publik DBConnectionManager {// SQLServer Private String drivername = "com.microsoft.sqlserver.jdbc.sqlserverDriver"; // Muat driver private string url = "jdbc: microsoft: sqlserver: // localhost: 1433; "SA"; // Database Login Nama Pengguna Private String Password = "Root"; // Database Login Password Private Static String Message = "Selamat, koneksi database normal!"; public void setDriverName (String newDriverName) {driverName = newDriverName; } public String getDriverName () {return driverName; } public void setUrl (String newurl) {url = newurl; } public String getUrl () {return url; } public void setUser (String newUser) {user = newUser; } public String getUser () {return user; } public void setPassword (String newPassword) {password = newPassword; } public string getPassword () {return kata sandi; } koneksi publik getConnection () {coba {class.forname (driverName); return driverManager.getConnection (url, pengguna, kata sandi); } catch (Exception e) {E.PrintStackTrace (); pesan = "Koneksi database gagal!"; kembali nol; }} public static void main (string [] args) {coba {dbconnectionManager dcm = dbconnectionManager baru (); Koneksi conn = dcm.getConnection (); System.out.println (pesan); } catch (Exception e) {E.PrintStackTrace (); }}} /// paket kedua net.jiaxiang.dao; impor java.sql.connection; impor java.sql.driverManager; Public Class Conn {// Definisi Meminta Variabel Tes Private Static String Message = "Selamat, koneksi basis data normal!"; //Connection method public static Connection getConnection(){ try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");//Load driver return DriverManager.getConnection( "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=master", "Xiyi Hidden Disk", "QWE199509060"); // Implementasikan Parameter Koneksi Nama Perpustakaan Nama Pengguna dan Kata Sandi} catch (Exception e) {message = "Koneksi database gagal!"; e.printstacktrace (); // cetak pengecualian pengembalian null; }} public static void main (string [] args) {getConnection (); // call connection system.out.println (pesan); // uji situasi}}Di atas adalah metode mengemudi menggunakan Java Web untuk menghubungkan MySQL dan SQLSever dalam file dan kelas JSP. Saya harap ini akan membantu semua orang. Jika Anda memiliki pertanyaan, silakan tinggalkan saya pesan dan editor akan membalas semua orang tepat waktu. Terima kasih banyak atas dukungan Anda ke situs web Wulin.com!